﻿

CREATE PROCEDURE [dbo].[proc_Department_GetList]
	/*
	(
	@parameter1 int = 5,
	@parameter2 datatype OUTPUT
	)
	*/
AS
	Select
	Id,
	ParentId,
	DName,
	Sort,bmbh,
	CompanyId From Department Order by Sort
	RETURN

